﻿CREATE TABLE [dbo].[Item] (
    [Id]           UNIQUEIDENTIFIER NOT NULL,
    [Name]         NCHAR (128)      NOT NULL,
    [DateActive]   DATE             CONSTRAINT [DF_Item_DateActive] DEFAULT (getdate()) NOT NULL,
    [DateInactive] DATE             NULL,
    [CompanyId]    UNIQUEIDENTIFIER NOT NULL,
    CONSTRAINT [PK_Item] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_Item_Company] FOREIGN KEY ([CompanyId]) REFERENCES [dbo].[Company] ([Id])
);

